SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetBulletinEmploymentLectureByNo]
    (
      @JOL_BulletinLecture_No INT
    )
AS 
    SELECT  JOL_BulletinLecture_No,
            JOL_BulletinLecture_Title,
            JOL_BulletinLecture_Speaker,
            JOL_BulletinLecture_Time,
            JOL_BulletinLecture_Position,
            JOL_BulletinLecture_Host,
            JOL_BulletinLecture_Organizer,
            JOL_BulletinLecture_Body,
            JOL_BulletinLecture_Remark,
            JOL_BulletinLecture_AddTime,
            JOL_BulletinLecture_AddUser,
            JOL_BulletinLecture_UpdateTime,
            JOL_BulletinLecture_UpdateUser,
            JOL_BulletinLecture_ClickNumber,
            JOL_BulletinLecture_IsSetTop
    FROM    dbo.JOL_BulletinEmploymentLecture

GO
